package com.vone.export;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import com.vone.entity.Basicdata;
import com.vone.entity.CsFinancingExperience;
import com.vone.entity.CsInnovationService;
import com.vone.entity.CsInnovationServiceDemand;
import com.vone.export.until.ExcelStyle;
import com.vone.export.until.ExcelStyleHight;

//创建创业服务，第五个sheet
public class EntrepreneurshipServiceSheet {
	
	String selected = "[ ✔ ] ";
	String unchecked = "[ ✖ ] ";
	private ExcelStyle excelstyle = null;
	private ExcelStyleHight excelstyleheight=null;
	
	@SuppressWarnings("deprecation")
	public void getEntrepreneurshipServiceSheet(Basicdata basicdatas){
		excelstyle = new ExcelStyle();// 实例化样式
		excelstyleheight=new ExcelStyleHight();
		//融资经历
		CsFinancingExperience rongzijingli = basicdatas.getCsfinancingexperience();
		//创业服务
		CsInnovationService chuangyefuwu = basicdatas.getCsinnovationservice();
		//服务需求（复选框）
		CsInnovationServiceDemand fuwuxuqiu = basicdatas.getCsinnovationservicedemand();
		
		
		HSSFWorkbook wb = (HSSFWorkbook) ExportUntil.workbook;
		//创建第一个sheet
		Sheet sheet5 = ExportUntil.workbook.createSheet("创业服务");
		//设置列的宽度(以字符为单位,20*256=20个字符),setColumnWidth(第几列,多少宽度*256)
		sheet5.setColumnWidth(0, 40 * 256);
		sheet5.setColumnWidth(1, 30 * 256);
		sheet5.setColumnWidth(2, 30 * 256);
		sheet5.setColumnWidth(3, 30 * 256);
		sheet5.setColumnWidth(4, 30 * 256);
		
		//在sheet里创建第一行，参数为行索引(excel的行)，可以是0～65535之间的任何一个
		HSSFRow row0 = (HSSFRow) sheet5.createRow(0);
		row0.setHeight((short) 800);
		
		//创建单元格（excel的单元格，参数为列索引，可以是0～255之间的任何一个
		HSSFCell tableCell = row0.createCell(0);
		tableCell.setCellValue("创业服务");
		row0.setHeight((short) 800);
		tableCell.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		sheet5.addMergedRegion(new CellRangeAddress(0,0,0,4));
		//设置单元格内容
		
		//合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		
		//设置第一行的高度
		row0.setHeight((short) 800);//参数500约等于0.9cm,34px
		
		//构建标题样式
		HSSFCellStyle tableCellStyle = wb.createCellStyle();
		tableCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); //左右居中
		tableCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//上下居中
		HSSFFont tableFont = wb.createFont();//构建字体
		tableFont.setFontName("宋体");//设置字体
		tableFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//设置粗体
		tableFont.setFontHeightInPoints((short) 12);//设置字体大小
		tableCellStyle.setFont(tableFont);//应用到样式
		tableCell.setCellStyle(tableCellStyle);//应用到单元格		
		//融资经历模块
		//在sheet里创建第1行
		HSSFRow row1 = (HSSFRow) sheet5.createRow(1);
		row1.setHeight((short) 800);
		HSSFCell row1_cell_0 = row1.createCell(0);
		HSSFCell row1_cell_1 = row1.createCell(1);
		//设置单元格内容
		row1_cell_0.setCellValue("融资经历");
		if(rongzijingli!=null && rongzijingli.getHas_equity_financing()!=null){
			row1_cell_1.setCellValue("股权融资（"+(Integer.parseInt(rongzijingli.getHas_equity_financing())==1?"有":"无")+"）");
		}else{
			row1_cell_1.setCellValue("股权融资（无）");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(1,1,1,4));
		
		
		row1_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row1_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		
		//在sheet里创建第2行
		HSSFRow row2 = (HSSFRow) sheet5.createRow(2);
		row2.setHeight((short) 800);
		
		
		HSSFCell row2_cell_1 = row2.createCell(1);
		HSSFCell row2_cell_2 = row2.createCell(2);
		HSSFCell row2_cell_3 = row2.createCell(3);
		HSSFCell row2_cell_4 = row2.createCell(4);
		
		
		row2_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row2_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row2_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row2_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row2_cell_1.setCellValue("投资人/投资机构");
		row2_cell_2.setCellValue("融资金额(万元￥)");
		row2_cell_3.setCellValue("所占股权比例");
		row2_cell_4.setCellValue("投资时间");
		
		//在sheet里创建第3行
		HSSFRow row3 = (HSSFRow) sheet5.createRow(3);
		row3.setHeight((short) 800);
		HSSFCell row3_cell_1 = row3.createCell(1);
		HSSFCell row3_cell_2 = row3.createCell(2);
		HSSFCell row3_cell_3 = row3.createCell(3);
		HSSFCell row3_cell_4 = row3.createCell(4);
		
		row3_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row3_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row3_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row3_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(rongzijingli!=null && rongzijingli.getHas_equity_financing()!=null){
			row3_cell_1.setCellValue(Integer.parseInt(rongzijingli.getHas_equity_financing())==1?rongzijingli.getInvestor():"无");
			row3_cell_2.setCellValue(Integer.parseInt(rongzijingli.getHas_equity_financing())==1?rongzijingli.getFinancing_amount():"无");
			row3_cell_3.setCellValue(Integer.parseInt(rongzijingli.getHas_equity_financing())==1?rongzijingli.getEquity_rate():"无");
			row3_cell_4.setCellValue(Integer.parseInt(rongzijingli.getHas_equity_financing())==1?rongzijingli.getFinancing_time():"无");
		}else{
			row3_cell_1.setCellValue("无");
			row3_cell_2.setCellValue("无");
			row3_cell_3.setCellValue("无");
			row3_cell_4.setCellValue("无");
		}
		
		//在sheet里创建第4行
		HSSFRow row4 = (HSSFRow) sheet5.createRow(4);
		row4.setHeight((short) 800);
		
		
		HSSFCell row4_cell_1 = row4.createCell(1);
		row4_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格

		//设置单元格内容
		if(rongzijingli!=null && rongzijingli.getHas_debt_financing()!=null){
			row4_cell_1.setCellValue("债权融资（"+(Integer.parseInt(rongzijingli.getHas_debt_financing())==1?"有":"无")+"）");
		}else{
			row4_cell_1.setCellValue("债权融资（无）");
		}
		
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(4,4,1,4));
		
		//在sheet里创建第5行
		HSSFRow row5 = (HSSFRow) sheet5.createRow(5);
		row5.setHeight((short) 800);
		
		HSSFCell row5_cell_1 = row5.createCell(1);
		HSSFCell row5_cell_2 = row5.createCell(2);
		HSSFCell row5_cell_3 = row5.createCell(3);
		HSSFCell row5_cell_4 = row5.createCell(4);
		
		row5_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row5_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row5_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row5_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row5_cell_1.setCellValue("出借方");
		row5_cell_2.setCellValue("贷款金额(万元￥)");
		row5_cell_3.setCellValue("贷款启动时间");
		row5_cell_4.setCellValue("贷款结束时间");
		
		//在sheet里创建第6行
		HSSFRow row6 = (HSSFRow) sheet5.createRow(6);
		row6.setHeight((short) 800);
		
		
		HSSFCell row6_cell_1 = row6.createCell(1);
		HSSFCell row6_cell_2 = row6.createCell(2);
		HSSFCell row6_cell_3 = row6.createCell(3);
		HSSFCell row6_cell_4 = row6.createCell(4);
		
		row6_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row6_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row6_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row6_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		if(rongzijingli!=null && rongzijingli.getHas_debt_financing()!=null){
			row6_cell_1.setCellValue(Integer.parseInt(rongzijingli.getHas_debt_financing())==1?rongzijingli.getLender():"无");
			row6_cell_2.setCellValue(Integer.parseInt(rongzijingli.getHas_debt_financing())==1?rongzijingli.getHas_debt_financing():"无");
			row6_cell_3.setCellValue(Integer.parseInt(rongzijingli.getHas_debt_financing())==1?rongzijingli.getLoan_start_time():"无");
			row6_cell_4.setCellValue(Integer.parseInt(rongzijingli.getHas_debt_financing())==1?rongzijingli.getLoan_end_time():"无");
		}else{
			row6_cell_1.setCellValue("无");
			row6_cell_2.setCellValue("无");
			row6_cell_3.setCellValue("无");
			row6_cell_4.setCellValue("无");
		}
		
		//在sheet里创建第7行
		HSSFRow row7 = (HSSFRow) sheet5.createRow(7);
		row7.setHeight((short) 800);
		
		HSSFCell row7_cell_1 = row7.createCell(1);
		HSSFCell row7_cell_2 = row7.createCell(2);
		
		row7_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row7_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row7_cell_1.setCellValue("现融资阶段");
		if(rongzijingli!=null && rongzijingli.getFinancing_stage()!=null){
			row7_cell_2.setCellValue(Integer.parseInt(rongzijingli.getFinancing_stage())==1?"天使":Integer.parseInt(rongzijingli.getFinancing_stage())==2?"A轮":Integer.parseInt(rongzijingli.getFinancing_stage())==3?"B轮":Integer.parseInt(rongzijingli.getFinancing_stage())==4?"C轮":Integer.parseInt(rongzijingli.getFinancing_stage())==5?"其他："+rongzijingli.getOther_stage_name():"");
		}else{
			row7_cell_2.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(7,7,2,4));
		
		//融资经历总跨行夸列数
		sheet5.addMergedRegion(new CellRangeAddress(1,7,0,0));
		
		
		
		//创业服务需求模块
		//在sheet里创建第8行
		HSSFRow row8 = (HSSFRow) sheet5.createRow(8);
		row8.setHeight((short) 800);
		
		HSSFCell row8_cell_0 = row8.createCell(0);
		HSSFCell row8_cell_1 = row8.createCell(1);
		
		row8_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row8_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row8_cell_0.setCellValue("创业服务需求");
		if(chuangyefuwu!=null && chuangyefuwu.getHas_equity_financing()!=null){
			row8_cell_1.setCellValue("股权融资（"+(Integer.parseInt(chuangyefuwu.getHas_equity_financing())==1?"有":"无")+"）");
		}else{
			row8_cell_1.setCellValue("股权融资（无）");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(8,8,1,4));
		
		//在sheet里创建第9行
		HSSFRow row9 = (HSSFRow) sheet5.createRow(9);
		row9.setHeight((short) 800);
		
		HSSFCell row9_cell_1 = row9.createCell(1);
		HSSFCell row9_cell_2 = row9.createCell(2);
		HSSFCell row9_cell_3 = row9.createCell(3);
		
		row9_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row9_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row9_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row9_cell_1.setCellValue("融资金额(万元￥)");
		row9_cell_2.setCellValue("拟出让股权比例");
		row9_cell_3.setCellValue("融资时间");
		
		//在sheet里创建第10行
		HSSFRow row10 = (HSSFRow) sheet5.createRow(10);
		row10.setHeight((short) 800);
		
		HSSFCell row10_cell_1 = row10.createCell(1);
		HSSFCell row10_cell_2 = row10.createCell(2);
		HSSFCell row10_cell_3 = row10.createCell(3);
		
		row10_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row10_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row10_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getHas_equity_financing()!=null){
			row10_cell_1.setCellValue(Integer.parseInt(chuangyefuwu.getHas_equity_financing())==1?chuangyefuwu.getEquity_financing_amount():"无");
			row10_cell_2.setCellValue(Integer.parseInt(chuangyefuwu.getHas_equity_financing())==1?chuangyefuwu.getEquity_rate():"无");
			row10_cell_3.setCellValue(Integer.parseInt(chuangyefuwu.getHas_equity_financing())==1?chuangyefuwu.getEquity_financing_time():"无");
		}else{
			row10_cell_1.setCellValue("无");
			row10_cell_2.setCellValue("无");
			row10_cell_3.setCellValue("无");
		}
		
		//在sheet里创建第11行
		HSSFRow row11 = (HSSFRow) sheet5.createRow(11);
		row11.setHeight((short) 3000);
		
		HSSFCell row11_cell_1 = row11.createCell(1);
		HSSFCell row11_cell_2 = row11.createCell(2);
		
		row11_cell_1.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		row11_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row11_cell_1.setCellValue("资金使用计划");
		if(chuangyefuwu!=null && chuangyefuwu.getHas_equity_financing()!=null){
			row11_cell_2.setCellValue(Integer.parseInt(chuangyefuwu.getHas_equity_financing())==1?chuangyefuwu.getEquity_fund_use_plan():"无");
		}else{
			row11_cell_2.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(11,11,2,4));
		
		//在sheet里创建第12行
		HSSFRow row12 = (HSSFRow) sheet5.createRow(12);
		row12.setHeight((short) 800);
		
		
		HSSFCell row12_cell_1 = row12.createCell(1);
		
		row12_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getIs_apply_credit_org()!=null){
			row12_cell_1.setCellValue("申请大赛组委会推荐投资机构："+(Integer.parseInt(chuangyefuwu.getIs_apply_credit_org())==1?"是":"否"));
		}else{
			row12_cell_1.setCellValue("申请大赛组委会推荐投资机构：否");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(12,12,1,4));
		
		//在sheet里创建第13行
		HSSFRow row13 = (HSSFRow) sheet5.createRow(13);
		row13.setHeight((short) 800);
		
		
		HSSFCell row13_cell_1 = row13.createCell(1);
		
		row13_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getHas_debt_financing()!=null){
			row13_cell_1.setCellValue("债权融资（"+(Integer.parseInt(chuangyefuwu.getHas_debt_financing())==1?"有":"无")+"）");
		}else{
			row13_cell_1.setCellValue("债权融资（无）");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(13,13,1,4));
		
		//在sheet里创建第14行
		HSSFRow row14 = (HSSFRow) sheet5.createRow(14);
		row14.setHeight((short) 800);
		
		
		HSSFCell row14_cell_1 = row14.createCell(1);
		HSSFCell row14_cell_2 = row14.createCell(2);
		HSSFCell row14_cell_3 = row14.createCell(3);
		
		row14_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row14_cell_1.setCellValue("融资金额(万元￥)");
		row14_cell_2.setCellValue("可以接受的最高年利率%");
		row14_cell_3.setCellValue("融资时间");
		
		//在sheet里创建第15行
		HSSFRow row15 = (HSSFRow) sheet5.createRow(15);
		row15.setHeight((short) 800);
		
		HSSFCell row15_cell_1 = row15.createCell(1);
		HSSFCell row15_cell_2 = row15.createCell(2);
		HSSFCell row15_cell_3 = row15.createCell(3);
		
		
		row15_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getHas_debt_financing()!=null){
			row15_cell_1.setCellValue(Integer.parseInt(chuangyefuwu.getHas_debt_financing())==1?chuangyefuwu.getDebt_financing_amount():"无");
			row15_cell_2.setCellValue(Integer.parseInt(chuangyefuwu.getHas_debt_financing())==1?chuangyefuwu.getAcceptable_max_annual_interest_rate():"无");
			row15_cell_3.setCellValue(Integer.parseInt(chuangyefuwu.getHas_debt_financing())==1?chuangyefuwu.getDebt_finaccing_time():"无");
		}else{
			row15_cell_1.setCellValue("无");
			row15_cell_2.setCellValue("无");
			row15_cell_3.setCellValue("无");
		}
		
		//在sheet里创建第16行
		HSSFRow row16 = (HSSFRow) sheet5.createRow(16);
		row16.setHeight((short) 3000);
		
		HSSFCell row16_cell_1 = row16.createCell(1);
		HSSFCell row16_cell_2 = row16.createCell(2);

		row16_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		row16_cell_1.setCellValue("资金使用计划");
		if(chuangyefuwu!=null && chuangyefuwu.getHas_debt_financing()!=null){
			row16_cell_2.setCellValue(Integer.parseInt(chuangyefuwu.getHas_debt_financing())==1?chuangyefuwu.getDebt_fund_use_plan():"无");
		}else{
			row16_cell_2.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(16,16,2,4));
		
		//在sheet里创建第17行
		HSSFRow row17 = (HSSFRow) sheet5.createRow(17);
		row17.setHeight((short) 800);
		
		
		HSSFCell row17_cell_1 = row17.createCell(1);

		row17_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getIs_apply_credit_org()!=null){
			row17_cell_1.setCellValue("申请大赛组委会推荐信贷机构："+(Integer.parseInt(chuangyefuwu.getIs_apply_credit_org())==1?"是":"否"));
		}else{
			row17_cell_1.setCellValue("申请大赛组委会推荐信贷机构：否");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(17,17,1,4));
		
		//在sheet里创建第18行
		HSSFRow row18 = (HSSFRow) sheet5.createRow(18);
		row18.setHeight((short) 800);
		
		
		HSSFCell row18_cell_1 = row18.createCell(1);
		
		row18_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getIs_apply_roadshow()!=null){
			row18_cell_1.setCellValue("申请中国创新创业大赛行业总决赛期间融资路演："+(Integer.parseInt(chuangyefuwu.getIs_apply_roadshow())==1?"是":"否"));
		}else{
			row18_cell_1.setCellValue("申请中国创新创业大赛行业总决赛期间融资路演：否");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(18,18,1,4));
		
		//在sheet里创建第19行
		HSSFRow row19 = (HSSFRow) sheet5.createRow(19);
		row19.setHeight((short) 800);
		
		
		HSSFCell row19_cell_1 = row19.createCell(1);
		
		row19_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		if(chuangyefuwu!=null && chuangyefuwu.getIs_apply_abutment_activity()!=null){
			row19_cell_1.setCellValue("申请中国创新创业大赛大企业对接活动："+(Integer.parseInt(chuangyefuwu.getIs_apply_abutment_activity())==1?"是":"否"));
		}else{
			row19_cell_1.setCellValue("申请中国创新创业大赛大企业对接活动：否");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(19,19,1,4));
		
		String is_zc_zqzc=unchecked;
		String is_zc_gqzc=unchecked;
		String is_zc_cpzc=unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getCrowdfunding()!=null){
			if(fuwuxuqiu.getCrowdfunding().length()>0){
				for (int i = 0; i < fuwuxuqiu.getCrowdfunding().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getCrowdfunding().split(",")[i].toString())==1)
						is_zc_zqzc=selected;
					if(Integer.parseInt(fuwuxuqiu.getCrowdfunding().split(",")[i].toString())==2)
						is_zc_gqzc=selected;
					if(Integer.parseInt(fuwuxuqiu.getCrowdfunding().split(",")[i].toString())==3)
						is_zc_cpzc=selected;
				}
			}
		}
		//在sheet里创建第20行
		HSSFRow row20 = (HSSFRow) sheet5.createRow(20);
		row20.setHeight((short) 800);
		
		
		HSSFCell row20_cell_1 = row20.createCell(1);
		HSSFCell row20_cell_2 = row20.createCell(2);
		
		row20_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row20_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row20_cell_1.setCellValue("众筹");
		row20_cell_2.setCellValue(is_zc_zqzc+"债权众筹");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(20,20,2,4));
		
		//在sheet里创建第21行
		HSSFRow row21 = (HSSFRow) sheet5.createRow(21);
		row21.setHeight((short) 800);
		
		
		HSSFCell row21_cell_2 = row21.createCell(2);
		row21_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row21_cell_2.setCellValue(is_zc_gqzc+"股权众筹");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(21,21,2,4));
		
		//在sheet里创建第22行
		HSSFRow row22 = (HSSFRow) sheet5.createRow(22);
		row22.setHeight((short) 800);
		
		
		HSSFCell row22_cell_2 = row22.createCell(2);
		
		row22_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row22_cell_2.setCellValue(is_zc_cpzc+"产品众筹");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(22,22,2,4));
		
		//众筹跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(20,22,1,1));
		
		String is_bg_1=unchecked;
		String is_bg_2=unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getMerge()!=null){
			if(fuwuxuqiu.getMerge().length()>0){
				for (int i = 0; i < fuwuxuqiu.getMerge().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getMerge().split(",")[i].toString())==1)
						is_bg_1=selected;
					if(Integer.parseInt(fuwuxuqiu.getMerge().split(",")[i].toString())==2)
						is_bg_2=selected;
				}
			}
		}
		//在sheet里创建第23行
		HSSFRow row23 = (HSSFRow) sheet5.createRow(23);
		row23.setHeight((short) 800);
		
		HSSFCell row23_cell_1 = row23.createCell(1);
		HSSFCell row23_cell_2 = row23.createCell(2);
		
		row23_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row23_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row23_cell_1.setCellValue("并购");
		row23_cell_2.setCellValue(is_bg_1+"愿意被上市公司并购");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(23,23,2,4));
		
		//在sheet里创建第24行
		HSSFRow row24 = (HSSFRow) sheet5.createRow(24);
		row24.setHeight((short) 800);
		
		HSSFCell row24_cell_2 = row24.createCell(2);
		
		row24_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row24_cell_2.setCellValue(is_bg_2+"愿意被上市公司并购");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(24,24,2,4));
		
		//并购跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(23,24,1,1));
		
		String is_ggs_1=unchecked;
		String is_ggs_2=unchecked;
		String is_ggs_3=unchecked;
		String is_ggs_4=unchecked;
		String is_ggs_5=unchecked;
		String is_ggs_6=unchecked;
		String is_ggs_7=unchecked;
		String is_ggs_8=unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getList()!=null){
			if(fuwuxuqiu.getList().length()>0){
				for (int i = 0; i < fuwuxuqiu.getList().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==1)
						is_ggs_1=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==2)
						is_ggs_2=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==3)
						is_ggs_3=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==4)
						is_ggs_4=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==5)
						is_ggs_5=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==6)
						is_ggs_6=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==7)
						is_ggs_7=selected;
					if(Integer.parseInt(fuwuxuqiu.getList().split(",")[i].toString())==8)
						is_ggs_8=selected;
				}
			}
		}
		//在sheet里创建第25行
		HSSFRow row25 = (HSSFRow) sheet5.createRow(25);
		row25.setHeight((short) 800);
		
		
		HSSFCell row25_cell_1 = row25.createCell(1);
		HSSFCell row25_cell_2 = row25.createCell(2);
		
		
		row25_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row25_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		row25_cell_1.setCellValue("股改、挂牌、上市");
		row25_cell_2.setCellValue(is_ggs_1+"主板");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(25,25,2,4));
		
		//在sheet里创建第26行
		HSSFRow row26 = (HSSFRow) sheet5.createRow(26);
		row26.setHeight((short) 800);
		
		
		HSSFCell row26_cell_2 = row26.createCell(2);
		
		row26_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row26_cell_2.setCellValue(is_ggs_2+"中小板");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(26,26,2,4));
		
		//在sheet里创建第27行
		HSSFRow row27 = (HSSFRow) sheet5.createRow(27);
		row27.setHeight((short) 800);
		
		HSSFCell row27_cell_2 = row27.createCell(2);
		row27_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row27_cell_2.setCellValue(is_ggs_3+"创业板");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(27,27,2,4));
		
		//在sheet里创建第28行
		HSSFRow row28 = (HSSFRow) sheet5.createRow(28);
		row28.setHeight((short) 800);
		
		HSSFCell row28_cell_2 = row28.createCell(2);
		
		row28_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		row28_cell_2.setCellValue(is_ggs_4+"新三板");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(28,28,2,4));
		
		//在sheet里创建第29行
		HSSFRow row29 = (HSSFRow) sheet5.createRow(29);
		row29.setHeight((short) 800);
		
		HSSFCell row29_cell_2 = row29.createCell(2);
		row29_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row29_cell_2.setCellValue(is_ggs_5+"上海股权托管交易中心");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(29,29,2,4));
		
		//在sheet里创建第30行
		HSSFRow row30 = (HSSFRow) sheet5.createRow(30);
		row30.setHeight((short) 800);
		
		HSSFCell row30_cell_2 = row30.createCell(2);
		
		row30_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row30_cell_2.setCellValue(is_ggs_6+"培训辅导");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(30,30,2,4));
		
		//在sheet里创建第31行
		HSSFRow row31 = (HSSFRow) sheet5.createRow(31);
		row31.setHeight((short) 800);
		
		HSSFCell row31_cell_2 = row31.createCell(2);
		
		row31_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row31_cell_2.setCellValue(is_ggs_7+"上市路演需求");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(31,31,2,4));
		
		//股改、挂牌、上市跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(25,31,1,1));
		
		//在sheet里创建第32行
		HSSFRow row32 = (HSSFRow) sheet5.createRow(32);
		row32.setHeight((short) 800);
		
		HSSFCell row32_cell_1 = row32.createCell(1);
		
		row32_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row32_cell_1.setCellValue(is_ggs_8+"融资担保");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(32,32,1,4));
		
		String is_xedk_1=unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getMicrofinance()!=null){
			if(fuwuxuqiu.getMicrofinance().length()>0){
				for (int i = 0; i < fuwuxuqiu.getMicrofinance().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getMicrofinance().split(",")[i].toString())==1)
						is_xedk_1=selected;
				}
			}
		}
		//在sheet里创建第33行
		HSSFRow row33 = (HSSFRow) sheet5.createRow(33);
		row33.setHeight((short) 800);
		
		
		HSSFCell row33_cell_1 = row33.createCell(1);
		HSSFCell row33_cell_3 = row33.createCell(3);
		
		row33_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row33_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		
		//设置单元格内容
		row33_cell_1.setCellValue(is_xedk_1+"小额贷款");
		if(fuwuxuqiu!=null && fuwuxuqiu.getMicrofinance_quota()!=null){
			row33_cell_3.setCellValue("额度："+fuwuxuqiu.getMicrofinance_quota()+"（万元人民币）");
		}else{
			row33_cell_3.setCellValue("额度_____（万元人民币）");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(33,33,1,2));
		sheet5.addMergedRegion(new CellRangeAddress(33,33,3,4));
		
		String is_jsyj_1=unchecked;
		String is_jsyj_2=unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getTec_import()!=null){
			if(fuwuxuqiu.getTec_import().length()>0){
				for (int i = 0; i < fuwuxuqiu.getTec_import().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getTec_import().split(",")[i].toString())==1)
						is_jsyj_1=selected;
					if(Integer.parseInt(fuwuxuqiu.getTec_import().split(",")[i].toString())==2)
						is_jsyj_2=selected;
				}
			}
		}
		//在sheet里创建第34行
		HSSFRow row34 = (HSSFRow) sheet5.createRow(34);
		row34.setHeight((short) 800);
		
		
		HSSFCell row34_cell_1 = row34.createCell(1);
		HSSFCell row34_cell_2 = row34.createCell(2);
		HSSFCell row34_cell_3 = row34.createCell(3);
		
		row34_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row34_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row34_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row34_cell_1.setCellValue("技术引进");
		row34_cell_2.setCellValue(is_jsyj_1+"国际技术范围");
		if(fuwuxuqiu!=null && fuwuxuqiu.getInternational_tec_range()!=null){
			row34_cell_3.setCellValue(fuwuxuqiu.getInternational_tec_range());
		}else{
			row34_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(34,34,3,4));
		
		//在sheet里创建第35行
		HSSFRow row35 = (HSSFRow) sheet5.createRow(35);
		row35.setHeight((short) 800);
		
		HSSFCell row35_cell_2 = row35.createCell(2);
		HSSFCell row35_cell_3 = row35.createCell(3);
		
		row35_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row35_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row35_cell_2.setCellValue(is_jsyj_2+"国内技术范围");
		if(fuwuxuqiu!=null && fuwuxuqiu.getDomestic_tec_range()!=null){
			row35_cell_3.setCellValue(fuwuxuqiu.getDomestic_tec_range());
		}else{
			row35_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(35,35,3,4));
		
		//技术引进跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(34,35,1,1));
		
		String is_jszr = unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getTec_transfer()!=null){
			if(fuwuxuqiu.getTec_transfer().length()>0){
				for (int i = 0; i < fuwuxuqiu.getTec_transfer().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getTec_transfer().split(",")[i].toString())==1)
						is_jszr=selected;
				}
			}
		}
		//在sheet里创建第36行
		HSSFRow row36 = (HSSFRow) sheet5.createRow(36);
		row36.setHeight((short) 800);
		
		HSSFCell row36_cell_1 = row36.createCell(1);
		HSSFCell row36_cell_2 = row36.createCell(2);
		HSSFCell row36_cell_3 = row36.createCell(3);
		
		row36_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row36_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row36_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row36_cell_1.setCellValue(is_jszr+"技术转让");
		row36_cell_2.setCellValue("技术范围");
		if(fuwuxuqiu!=null && fuwuxuqiu.getTec_range()!=null){
			row36_cell_3.setCellValue(fuwuxuqiu.getTec_range());
		}else{
			row36_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(36,36,3,4));
		
		//在sheet里创建第37行
		HSSFRow row37 = (HSSFRow) sheet5.createRow(37);
		row37.setHeight((short) 800);
		
		
		HSSFCell row37_cell_1 = row37.createCell(1);
		row37_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getProperty_transfer()!=null){
			row37_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getProperty_transfer())==1?selected:unchecked)+"产权转让");
		}else{
			row37_cell_1.setCellValue(unchecked+"产权转让");
			
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(37,37,1,4));
		
		//在sheet里创建第38行
		HSSFRow row38 = (HSSFRow) sheet5.createRow(38);
		row38.setHeight((short) 800);
		
		
		HSSFCell row38_cell_1 = row38.createCell(1);
		row38_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getFinancial_lease()!=null){
			row38_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getFinancial_lease())==1?selected:unchecked)+"金融租赁");
		}else{
			row38_cell_1.setCellValue(unchecked+"金融租赁");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(38,38,1,4));
		
		//在sheet里创建第39行
		HSSFRow row39 = (HSSFRow) sheet5.createRow(39);
		row39.setHeight((short) 800);
		
		HSSFCell row39_cell_1 = row39.createCell(1);
		
		row39_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getTec_insurance()!=null){
			row39_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getTec_insurance())==1?selected:unchecked)+"科技保险");
		}else{
			row39_cell_1.setCellValue(unchecked+"科技保险");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(39,40,1,4));
		
		
		//在sheet里创建第41行
		HSSFRow row41 = (HSSFRow) sheet5.createRow(41);
		row41.setHeight((short) 800);
		
		HSSFCell row41_cell_1 = row41.createCell(1);
		
		row41_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getAsset_management()!=null){
			row41_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getAsset_management())==1?selected:unchecked)+"资产管理");
		}else{
			row41_cell_1.setCellValue(unchecked+"资产管理");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(41,41,1,4));
		
		//在sheet里创建第42行
		HSSFRow row42 = (HSSFRow) sheet5.createRow(42);
		row42.setHeight((short) 800);
		HSSFCell row42_cell_1 = row42.createCell(1);
		
		row42_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getOccupancy_incubator()!=null){
			row42_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getOccupancy_incubator())==1?selected:unchecked)+"入住高新区园区/孵化器");
		}else{
			row42_cell_1.setCellValue(unchecked+"入住高新区园区/孵化器");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(42,42,1,4));
		
		//在sheet里创建第43行
		HSSFRow row43 = (HSSFRow) sheet5.createRow(43);
		row43.setHeight((short) 800);
		
		HSSFCell row43_cell_1 = row43.createCell(1);
		
		row43_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getPolicy_consultation()!=null){
			row43_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getPolicy_consultation())==1?selected:unchecked)+"政策咨询");
		}else{
			row43_cell_1.setCellValue(unchecked+"政策咨询");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(43,43,1,4));
		
		//在sheet里创建第44行
		HSSFRow row44 = (HSSFRow) sheet5.createRow(44);
		row44.setHeight((short) 800);
		
		
		HSSFCell row44_cell_1 = row44.createCell(1);
		
		row44_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getTec_consulting()!=null){
			row44_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getTec_consulting())==1?selected:unchecked)+"科技咨询");
		}else{
			row44_cell_1.setCellValue(unchecked+"科技咨询");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(44,44,1,4));
		
		String is_zjzx_1 = unchecked;
		String is_zjzx_2 = unchecked;
		String is_zjzx_3 = unchecked;
		String is_zjzx_4 = unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getIntermediary_consulting()!=null){
			if(fuwuxuqiu.getIntermediary_consulting().length()>0){
				for (int i = 0; i < fuwuxuqiu.getIntermediary_consulting().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getIntermediary_consulting().split(",")[i].toString())==1)
						is_zjzx_1=selected;
					if(Integer.parseInt(fuwuxuqiu.getIntermediary_consulting().split(",")[i].toString())==2)
						is_zjzx_2=selected;
					if(Integer.parseInt(fuwuxuqiu.getIntermediary_consulting().split(",")[i].toString())==3)
						is_zjzx_3=selected;
					if(Integer.parseInt(fuwuxuqiu.getIntermediary_consulting().split(",")[i].toString())==4)
						is_zjzx_4=selected;
				}
			}
		}
		//在sheet里创建第45行
		HSSFRow row45 = (HSSFRow) sheet5.createRow(45);
		row45.setHeight((short) 800);
		
		HSSFCell row45_cell_1 = row45.createCell(1);
		HSSFCell row45_cell_2 = row45.createCell(2);
		HSSFCell row45_cell_3 = row45.createCell(3);
		
		row45_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row45_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row45_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row45_cell_1.setCellValue("中介咨询");
		row45_cell_2.setCellValue(is_zjzx_1+"法律");
		if(fuwuxuqiu!=null && fuwuxuqiu.getIntermediary_law()!=null){
			row45_cell_3.setCellValue(fuwuxuqiu.getIntermediary_law());
		}else{
			row45_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(45,45,3,4));
		
		//在sheet里创建第46行
		HSSFRow row46 = (HSSFRow) sheet5.createRow(46);
		row46.setHeight((short) 800);
		
		HSSFCell row46_cell_2 = row46.createCell(2);
		HSSFCell row46_cell_3 = row46.createCell(3);
		
		row46_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row46_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		
		//设置单元格内容
		row46_cell_2.setCellValue(is_zjzx_2+"财务");
		if(fuwuxuqiu!=null && fuwuxuqiu.getIntermediary_financial()!=null){
			row46_cell_3.setCellValue(fuwuxuqiu.getIntermediary_financial());
		}else{
			row46_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(46,46,3,4));
		
		//在sheet里创建第47行
		HSSFRow row47 = (HSSFRow) sheet5.createRow(47);
		row47.setHeight((short) 800);
		
		HSSFCell row47_cell_2 = row47.createCell(2);
		HSSFCell row47_cell_3 = row47.createCell(3);
		
		row47_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row47_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row47_cell_2.setCellValue(is_zjzx_3+"融资");
		if(fuwuxuqiu!=null && fuwuxuqiu.getIntermediary_financing()!=null){
			row47_cell_3.setCellValue(fuwuxuqiu.getIntermediary_financing());
		}else{
			row47_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(47,47,3,4));
		
		//在sheet里创建第48行
		HSSFRow row48 = (HSSFRow) sheet5.createRow(48);
		row48.setHeight((short) 800);
		
		
		HSSFCell row48_cell_2 = row48.createCell(2);
		HSSFCell row48_cell_3 = row48.createCell(3);
		
		row48_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row48_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		
		//设置单元格内容
		row48_cell_2.setCellValue(is_zjzx_4+"管理");
		if(fuwuxuqiu!=null && fuwuxuqiu.getIntermediary_manage()!=null){
			row48_cell_3.setCellValue(fuwuxuqiu.getIntermediary_manage());
		}else{
			row48_cell_3.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(48,48,3,4));
		
		//中介咨询跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(45,48,1,1));
		
		//在sheet里创建第49行
		HSSFRow row49 = (HSSFRow) sheet5.createRow(49);
		row49.setHeight((short) 800);
		
		
		HSSFCell row49_cell_1 = row49.createCell(1);
		HSSFCell row49_cell_2 = row49.createCell(2);
		
		row49_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row49_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		if(fuwuxuqiu!=null && fuwuxuqiu.getOther_service_demand_checkbox()!=null){
			row49_cell_1.setCellValue((Integer.parseInt(fuwuxuqiu.getOther_service_demand_checkbox())==1?selected:unchecked)+"其它服务需求");
			row49_cell_2.setCellValue(fuwuxuqiu.getOther_service_demand());
		}else{
			row49_cell_1.setCellValue(unchecked+"其它服务需求");
			row49_cell_2.setCellValue("无");
		}
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(49,49,2,4));
		
		
		String is_sqzg_1 = unchecked;
		String is_sqzg_2 = unchecked;
		String is_sqzg_3 = unchecked;
		String is_sqzg_4 = unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getApply_train()!=null){
			if(fuwuxuqiu.getApply_train().length()>0){
				for (int i = 0; i < fuwuxuqiu.getApply_train().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getApply_train().split(",")[i].toString())==1)
						is_sqzg_1=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_train().split(",")[i].toString())==2)
						is_sqzg_2=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_train().split(",")[i].toString())==3)
						is_sqzg_3=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_train().split(",")[i].toString())==4)
						is_sqzg_4=selected;
				}
			}
		}
		//在sheet里创建第50行
		HSSFRow row50 = (HSSFRow) sheet5.createRow(50);
		row50.setHeight((short) 800);
		
		
		HSSFCell row50_cell_1 = row50.createCell(1);
		HSSFCell row50_cell_2 = row50.createCell(2);
		
		
		row50_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row50_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row50_cell_1.setCellValue("申请中国创新创业大赛创业培训");
		row50_cell_2.setCellValue(is_sqzg_1+"参赛培训");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(50,50,2,4));
		
		//在sheet里创建第51行
		HSSFRow row51 = (HSSFRow) sheet5.createRow(51);
		row51.setHeight((short) 800);
		
		
		HSSFCell row51_cell_2 = row51.createCell(2);
		
		row51_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row51_cell_2.setCellValue(is_sqzg_2+"商业计划书辅导");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(51,51,2,4));
		
		//在sheet里创建第52行
		HSSFRow row52 = (HSSFRow) sheet5.createRow(52);
		row52.setHeight((short) 800);
		
		
		HSSFCell row52_cell_2 = row52.createCell(2);
		row52_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row52_cell_2.setCellValue(is_sqzg_3+"行业深度培训");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(52,52,2,4));
		
		//在sheet里创建第53行
		HSSFRow row53 = (HSSFRow) sheet5.createRow(53);
		row53.setHeight((short) 800);
		
		
		HSSFCell row53_cell_2 = row53.createCell(2);
		row53_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		
		//设置单元格内容
		row53_cell_2.setCellValue(is_sqzg_4+"其它");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(53,53,2,4));
		
		//申请中国创新创业大赛创业培训跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(50,53,1,1));
		
		String is_sqgj_1 = unchecked;
		String is_sqgj_2 = unchecked;
		String is_sqgj_3 = unchecked;
		String is_sqgj_4 = unchecked;
		String is_sqgj_5 = unchecked;
		String is_sqgj_6 = unchecked;
		String is_sqgj_7 = unchecked;
		String is_sqgj_8 = unchecked;
		if(fuwuxuqiu!=null && fuwuxuqiu.getApply_fund_recommend()!=null){
			if(fuwuxuqiu.getApply_fund_recommend().length()>0){
				for (int i = 0; i < fuwuxuqiu.getApply_fund_recommend().split(",").length; i++) {
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==1)
						is_sqgj_1=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==2)
						is_sqgj_2=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==3)
						is_sqgj_3=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==4)
						is_sqgj_4=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==5)
						is_sqgj_5=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==6)
						is_sqgj_6=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==7)
						is_sqgj_7=selected;
					if(Integer.parseInt(fuwuxuqiu.getApply_fund_recommend().split(",")[i].toString())==8)
						is_sqgj_8=selected;
				}
			}
		}
		//在sheet里创建第54行
		HSSFRow row54 = (HSSFRow) sheet5.createRow(54);
		row54.setHeight((short) 2000);
		
		
		HSSFCell row54_cell_1 = row54.createCell(1);
		HSSFCell row54_cell_2 = row54.createCell(2);
		
		row54_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row54_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row54_cell_1.setCellValue("申请国家科技成果转化引导基金设立的子基金推荐");
		row54_cell_2.setCellValue(is_sqgj_1+"北京国科瑞华战略性新兴产业投资基金（有限合伙）基金规模：221619万元，投资领域：高端装备制造、信息技术、消费与生命健康");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(54,54,2,4));
		
		//在sheet里创建第55行
		HSSFRow row55 = (HSSFRow) sheet5.createRow(55);
		row55.setHeight((short) 2000);
		
		
		HSSFCell row55_cell_2 = row55.createCell(2);
		
		row55_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row55_cell_2.setCellValue(is_sqgj_2+"北京君联成业股权投资合伙企业（有限合伙）基金规模：170000万元，投资领域：智能制造、专业服务、TMT及创新消费");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(55,55,2,4));
		
		//在sheet里创建第56行
		HSSFRow row56 = (HSSFRow) sheet5.createRow(56);
		row56.setHeight((short) 2000);
		
		
		HSSFCell row56_cell_2 = row56.createCell(2);
		
		row56_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row56_cell_2.setCellValue(is_sqgj_3+"天津天创盈鑫创业投资合伙企业      基金规模：28600万元，投资领域：节能环保、信息技术、先进制造");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(56,56,2,4));
		
		//在sheet里创建第57行
		HSSFRow row57 = (HSSFRow) sheet5.createRow(57);
		row57.setHeight((short) 2000);
		
		HSSFCell row57_cell_2 = row57.createCell(2);
		
		row57_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		row57_cell_2.setCellValue(is_sqgj_4+"国投（上海）科技成果转化创业投资基金企业（有限合伙） 基金规模：1000000万元，投资领域：电子信息、先进制造、能源环保、生物医药等领域重大专项科技成果转化");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(57,57,2,4));
		
		//在sheet里创建第58行
		HSSFRow row58 = (HSSFRow) sheet5.createRow(58);
		row58.setHeight((short) 2000);
		
		HSSFCell row58_cell_2 = row58.createCell(2);
		row58_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row58_cell_2.setCellValue(is_sqgj_5+"国投京津冀科技成果转化创业投资基金（有限合伙）基金规模：100000万元，投资领域：信息技术、先进制造、生物医药等");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(58,58,2,4));
		
		//在sheet里创建第59行
		HSSFRow row59 = (HSSFRow) sheet5.createRow(59);
		row59.setHeight((short) 2000);
		
		HSSFCell row59_cell_2 = row59.createCell(2);
		row59_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row59_cell_2.setCellValue(is_sqgj_6+"新能源汽车科技创新（合肥）股权投资合伙企业（有限合伙） 基金规模：50000万元，投资领域： 新能源汽车及相关产业");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(59,59,2,4));
		
		//在sheet里创建第60行
		HSSFRow row60 = (HSSFRow) sheet5.createRow(60);
		row60.setHeight((short) 2000);
		
		
		
		HSSFCell row60_cell_2 = row60.createCell(2);
		row60_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		
		//设置单元格内容
		row60_cell_2.setCellValue(is_sqgj_7+"上海高特佳懿海投资合伙企业（有限合伙） 基金规模：35243.2万元， 投资领域： 生物医药等");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(60,60,2,4));
		
		//在sheet里创建第61行
		HSSFRow row61 = (HSSFRow) sheet5.createRow(61);
		row61.setHeight((short) 2000);
		
		HSSFCell row61_cell_2 = row61.createCell(2);
		row61_cell_2.setCellStyle(excelstyleheight.getCellStyleheader());// 应用到单元格
		//设置单元格内容
		row61_cell_2.setCellValue(is_sqgj_8+"苏州瑞华投资合伙企业（有限合伙） 基金规模：100000 万元，投资领域： 生物医药、电子信息、新材料");
		//跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(61,61,2,4));
		
		//申请国家科技成果转化引导基金设立的子基金推荐跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(54,61,1,1));
		
		//创业服务需求模块跨行夸列
		sheet5.addMergedRegion(new CellRangeAddress(8,61,0,0));
	}


}
